SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
Create Procedure [dbo].[spThemDoanhThu]
	@tongTienBan int,
	@tongTienNhap int,
	@chiPhiKhac int,
	@luongNV int,
	@doanhThu int,
	@ngayTongKet datetime,
	@maNH int
	
As
Begin
	Insert Into DoanhThu
	(
		TongTienBan,
		TongTienBan,
		ChiPhiKhac,
		LuongNV,
		DoanhThu,
		NgayTongKet,
		MaNH
	)
	Values
	(
		@tongTienBan,
		@tongTienNhap,
		@chiPhiKhac,
		@luongNV ,
		@doanhThu ,
		@NgayTongKet,
		@maNH 
		
	)
End